RetailTransactionRestrictionValidation

Entity Definition

Logical Name : RetailTransactionRestrictionValidation
Physical Name : NA_RTL_TRN_RSTRCTN_VLD

A place to capture a customer's response to a question posed as part of enforcing a retailer's sales restriction rules. An example is the customer's answer when asked his/her age before selling cigarettes or alcoholic beverages. The question is triggered by a specific line item in customer transaction, but it is asked one time within the context of the transaction.

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
TransactionID (FK)(PK)	A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members.	ID_TRN	IdentityUUID	char(32)	RetailTransaction(TR_RTL)
QuestionID (FK)(PK)	A unique identifer for the restriction validation question.	ID_QST_RST_VLD	Identity	integer	RestrictionValidationQuestion(CO_VLD_RST_QST)
CustomerResponse	A text note that captures the customer's response to a sales restriction question.	DE_CT_RSPS	DescriptionShort	VARCHAR(255)

Relationships

Parent Entity	Verb Phrase	Child Entity
RetailTransaction	is subject to	RetailTransactionRestrictionValidation
RestrictionValidationQuestion	applies to	RetailTransactionRestrictionValidation
RetailTransactionRestrictionValidation	validates compliance of	RetailTransactionRestrictionValidationResult

Logical Views containing RetailTransactionRestrictionValidation

Logical View
Logical 02350 - Retail Transaction - Restriction Validation View